Data Professionals Survey Dashboard (Power BI)

Project Details

Goal & context. This project delivers an interactive Power BI dashboard to surface industry-wide trends from a public survey of data professionals (Alex The Analyst). The aim was to turn survey responses into a single, navigable view of compensation, roles, skills, and satisfaction so professionals and hiring managers could quickly see what the data industry looks like today.

Data cleaning & preparation. The raw survey dataset was validated and prepared in Power Query: nulls and inconsistent values were handled, text fields were standardized (e.g., job titles and programming languages), and numeric fields such as salary were cleaned and formatted. Date and categorical columns were shaped so they could drive filters and breakdowns reliably across the report.

Data modeling. A star-style model was set up in Power BI: a central fact table of survey responses linked to dimension tables for roles, demographics, and other attributes. Relationships were defined with appropriate cardinality and filter direction so that slicers and visuals would behave correctly. Measures were written in DAX for key metrics (e.g., average salary by segment, counts, and simple ratios) to support consistent analysis across pages.

Visualization & dashboard design. The report is organized into focused views—salary trends, job roles, programming languages, career transitions, and job satisfaction—with a consistent color palette and layout. Appropriate chart types were chosen (e.g., bar and column charts for comparisons, cards for KPIs) and cross-filtering was enabled so users can slice by role, experience, or geography. Tooltips and clear labels were added to make the insights self-explanatory.

Outcome. The dashboard provides a single, reusable view of data-professional survey insights, demonstrating end-to-end delivery in Power BI from raw data through cleaning, modeling, and user-oriented visualization.